SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[Main_Get_PageContent]
@ControllerName VARCHAR(150), @PageName VARCHAR(150), @ContentName VARCHAR(150)
AS
SELECT PageContent 
FROM dbo.Main_PageContent
INNER JOIN dbo.Main_Page ON dbo.Main_PageContent.PageId = dbo.Main_Page.Id
WHERE ControllerName = @ControllerName AND PageName = @PageName AND ContentName = @ContentName
GO
